from openpyxl import load_workbook
import yaml


def load_excel(file_path, sheet_name):
    wb = load_workbook(file_path)
    ws = wb[sheet_name]
    col = ws.max_column + 1
    row = ws.max_row + 1
    data = ({ws.cell(1, j).value: ws.cell(i, j).value for j in range(1, col)} for i in range(2, row))
    return data


def load_yml(file_path, sheet_name):
    with open(file_path, 'r', encoding='utf-8') as file:
        data = yaml.safe_load(file)
        return data


res = load_excel('../case_data/case_data.xlsx', 'register')

for i in res:
    print(f"{i}")
